Fanzhou Liang

Preferred Name: “Frank”

Email: fzlianguk@gmail.com | Phone: (+44) 07741948501

GitHub: https://github.com/FzliangFrank

LinkedIn: https://www.linkedin.com/in/frank-liang/

Instagram: https://www.instagram.com/franklyarts/

Profile

I am an experienced data professional with strong technical skills. I have the rare linguistic ability (I speak two languages) and am able to use several programming languages simultaneously (R, Python, SQL, JavaScript,even Visual Basic). I am self-taught, highly motivated individual with a strong desire to learn. I have a passion for data. I seek to work with “true big data” in my next role. My calling is becoming a Data Architect. I aim to achieve this by starting work as a Data Engineer and challenging myself with heavier data volume. Outside work, I enjoy art and music. I share digital drawings on my Instagram.

Technical Skill

  • Solid ELT (Extract Load Transform) skills for large geo-spatial data (typically 100,000 rows). For example:
    • Restore historical version of data using change logs table without time series database in pure PostgreSQL;
    • Create computationally efficient spatial join in the absence of GIS spatial indexing.
  • Experience applying natural language processing (in commercial experience) and long paragraphs (Latent-Dirichlet-Allocation for my academic project).
  • Familiar with HTML, JavaScript and modern Web development frameworks such as DJANGO, ReactJS, and CSS; in fact, this CV is styled with CSS.

  • R-programming (Tidyverse, igrap, tmap)

  • Python (Pandas, Vega Altair, ibis)

  • Postgre SQL + PostGIS

  • Delta Lake

  • Text-mining & Topic Modelling

  • Excel Macro & Visual Basics

  • R-Shiny application

  • Tensorflow

Work Experience

04/2022 – present | Full Fibre Limited | Data Analyst / System Developer | Exeter, England, UK

  • Delivered the company’s first semi-automated data for fibre optic testing, which was three times faster than manual human input.
  • Delivered the company’s first data-driven financial reporting for the 2023 annual audit;
  • Further automated several recurring reports, such as monthly service billing, annual carbon footprint, weekly build report;
  • Participated in software procurement and advised the
  • Prototyped the first algorithm that would fully automate low-level planning using applied graph theory;
  • The first to prototype the company’s fibre routing report and data validation strategy.
  • I onboarded and buddied two mid-level colleagues during their first three months.
  • Taught Postgres SQL training courses to several non-technical colleagues.

11/2021 - 01/2022 | Marks and Spencer | General Customer Assistant | Exeter, England, UK

  • Customer service: delivering a great shopping experience for their customers.

Voluntary Experiences

03/2022 –05/2022 | Exeter Green Party | Database Support | Exeter

  • Generic ad-hoc requests and data transformations. Worked with MySQL workbench.

11/2021 – 03/2022 | Forage | KPMG Data Analytic Virtual Internship| Virtual, at home

  • A virtual experience program that replicated the type of work KPMG graduates do with hypothetical data.
  • Data quality assessment: assess data quality and communicate with clients concisely. Data insights: explore data to propose efficient data-analytic models.

09/2017 – 07/2018 | Henan University of Technology | Student Interpreter, Volunteered as an interpreter for foreign teaching staff.

Education

2020 - 2021 | University of Exeter | MSc Business Analytics (merit)

  • A data-centric master programme at one of the UK’s top 10 universities.
  • I was interviewed and successfully selected for the QTEM (Quantitative Technique for Economic and Management) program, but voluntarily withdrew to pursue visa status.
  • I achieved a distinction for my final project, in which I used topic modelling to identify research funding opportunities.

2018 - 2020 | Cardiff Metropolitan University | BA Business Management with (Pathway) Human Resource Management (distinction, 1:1)

  • A comprehensive education of best business practices with an extra focus on human resources management.

2016 - 2018 | Henan University of Technology | BA Human Resource Management with Third Year Abroad

  • Bachelor’s degree with robust mathematics (calculous, matrix, probability theory) foundation taught in the first year.
  • Taught and examined in full English; Achieved distinction for all English modules and awarded two scholarships.

Professional Qualification

Since 2016 ACCA (5/13)

  • Three Foundational module Plus
  • Financial management (FM)
  • Performance management (PM)

Portfolios

Identify Research Funding Trends using Topic Modelling. This is my Master’s thesis. A project features Topic Modelling (LDA) and natural language processing for scope research funding for artificial intelligence. Full report here: https://github.com/FzliangFrank/Fzliang-UoE-2022

Network Data Utility tool. A R-Shiny App Tool Kit for interactive network visualisation. There are several prewritten modules that enables a user to search a particular node or edges based on identity or attribute. A demo of a web app written use this package is hosted on shiny.io: https://frank-the-tank.shinyapps.io/networkutils/

LLoyd Bank Statement Reader A Python package which reads a pdf bank statement into .csv, which I used to analyse my personal financial well-being. Repo here: https://github.com/FzliangFrank/pdf_bank_statement.

Interests & Activities

Café Laptop Hoper: Serial laptop hopper frowned by café owners across Cardiff and Exeter. Often found colonising coffee tables coding with my 14-inch MacBook.

Violin performance: few awards performing as a student violinist. Before the pandemic, I was briefly in a non-profit local Orchestra in Cardiff, South Wales

Realistic Drawing: A less noisy hobby. I have a art Instagram: https://www.instagram.com/franklyarts/.

My Playlist: Taylor Swift, Flume, French 79, IMANU…